Data Transfer (Available only in Full Version)

Navicat allows you to transfer tables/views/functions/sequences/events from one database/schema to another database/schema, or to a sql file. The target database/schema can be on the same server as the source database/schema or on another server. It also allows you to save a profile for easy retrieval and running of data transfer between databases/schemas. You can also invoke data transfer from the command line, which makes it possible to schedule data transfer between databases/schemas. You can save your settings as a profile for setting schedule.

Simply open the data transfer and use the toolbar below, which allows you to create, save and delete the data transfer.

Create Data Transfer

To create a new data transfer

To create a new data transfer with modification as one of the existing data transfer profiles

Hint: To create new data transfer, you can also control-click the database/schema node in the navigation pane and select the Data Transfer from the popup menu.

Edit Data Transfer

To edit the existing data transfer

Run Data Transfer

To run a data transfer

To run a saved data transfer profile from the command line

Delete Data Transfer

To delete a data transfer